Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NVL

The NVL function replaces a `NA` value with a string.

To evaluate a specified expression and replace a non-`NA` value with one value and a `NA` value with another, use NVL2.

Return Value

The specified replacement value when the value of the base expression is `NA`, or the base expression when the value of the base expression is not `NA`. The data type of the return value is always the same as the data type of the base expression.

Syntax

NVL (exp , replacement-exp)

Arguments

expr

  The expression that you want to replace when it has a `NA` value.

replacement-exp

  The value with which you want to replace a `NA` value.